RetailTransactionLineItemResourceOverride

Entity Definition

Logical Name : RetailTransactionLineItemResourceOverride
Physical Name : TR_LTM_RTL_TRN_OVR

A record of the OperatorID of the supervisor who authorized access to the RetailTransactionLineItem based Resource that the Operator of record was denied access to. This is an OVERRIDE that enables a manager to modify retail transaction line item attributes that are normally not accessible for update by an operator. An override represents an exception condition that is typcially closely watched by loss prevention and audit staff to ensure that the retailer is not being disadvanteged. Often overrides are used by managers to grant customers return privliges that might not otherwise have been available (e.g. accpepting a return without a receipt).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransactionLineItem(TR_LTM_RTL_TRN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
ResourceOverrideSequenceNumber (PK) Line number (incremental counter) AI_OVR_RS Number integer
ResourceID (FK) A unqiue system assigned identifier for the action to which access may be granted to some Operators and Workstations. ID_RS Identity integer Resource(PA_RS)
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
Timestamp The date and time that a transaction line item is being overridden. TS_LTM_RTL_TRN_OVR AuditDateTime datetime
EntryMethodCode A code denoting how the overriding OperatorID was entered. e.g. Keyed, Scanned, MCR, SmartCard, etc... LU_MTH_ENR Code2 char(2)
OverrideApprovalCode Approval code entered by the overriding Operator to complete the override authorization. CD_APVL_OVR Code4 char(4)
ApproverName The name of the person assigned to the OperatorID that was used to approve this LineItemResourceOverride NM_APRVR Name varchar(40)
Description A narrative describing the access control override, and the reasons for granting it. DE_OVR DescriptionNarrative varchar(4000)

Relationships

Parent Entity Verb Phrase Child Entity
Operator authorizes RetailTransactionLineItemResourceOverride
RetailTransactionLineItem is overridden by RetailTransactionLineItemResourceOverride
Resource access was overridden by RetailTransactionLineItemResourceOverride
Reason classifies RetailTransactionLineItemResourceOverride

Logical Views containing RetailTransactionLineItemResourceOverride

Logical View
Logical 02305 - Retail Transaction - Header View
Logical 02312 - Retail Transaction - Item Voids View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 06220 - Access Control - Overrides View
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View